1 <?php
2 error_reporting(0);
3 if(isset($_POST['submit']))
4 {
5 $issue=$_POST['issue'];
6 $description=$_POST['description'];
7 $email=$_SESSION['login'];
8 $sql="INSERT INTO tblissues(UserEmail,Issue,Description) VALUES(:email,:issue,:description)";
9 $query = $dbh->prepare($sql);
10 $query->bindParam(':issue',$issue,PDO::PARAM_STR);
11 $query->bindParam(':description',$description,PDO::PARAM_STR);
12 $query->bindParam(':email',$email,PDO::PARAM_STR);
13 $query->execute();
14 $lastInsertId = $dbh->lastInsertId();
15 if($lastInsertId)
16 {
17 $_SESSION['msg']="Info successfully submited ";
18 echo "<script type='text/javascript'> document.location = 'thankyou.php'; </script>";
19 }
20 else
21 {
22 $_SESSION['msg']="Something went wrong. Please try again.";
23 echo "<script type='text/javascript'> document.location = 'thankyou.php'; </script>";
24 }
25 }
26 ?>
27
28 <div class="modal fade" id="myModal3" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
29 <div class="modal-dialog" role="document">
30 <div class="modal-content">
31 <div class="modal-header">
32 <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
33 </div>
34 <section>
35 <form name="help" method="post">
36 <div class="modal-body modal-spa">
37 <div class="writ">
38 <h4>HOW CAN WE HELP YOU</h4>
39 <ul>
40
41 <li class="na-me">
42 <select id="country" name="issue" class="frm-field required sect" required="">
43 <option value="">Select Issue</option>
44 <option value="Booking Issues">Booking Issues</option>
45 <option value="Cancellation"> Cancellation</option>
46 <option value="Refund">Refund</option>
47 <option value="Other">Other</option>
48 </select>
49 </li>
50
51 <li class="descrip">
52 <input class="special" type="text" placeholder="description" name="description" required="">
53 </li>
54 <div class="clearfix"></div>
55 </ul>
56 <div class="sub-bn">
57 <form>
58 <button type="submit" name="submit" class="subbtn">Submit</button>
59 </form>
60 </div>
61 </div>
62 </div>
63 </form>
64 </section>
65 </div>
66 </div>
67 </div>